1. Create Worksheets and Workbooks 1.1  Create Worksheets and Workbooks Create New Blank Workbooks, Pg 27 1.3  Format Worksheets and Workbooks Change Row Height and Column Width, Pg 30 1.4  Customize Options and Views for Worksheets and Workbooks Hide Rows and Columns, Pg 60 Workbook Views: Change Views, Pg 192 Workbook Views: Zoom, Pg 196 Workbook Views: Freeze Panes, Pg 198 Workbook Views: Split the Window, Pg 197 1.5  Configure Worksheets and Workbooks to Print Or Save Save: Maintain Backward Compatibility, Pg 73 2. Create Cells and Ranges 2.1 Insert Data In Cells and Ranges Copy and Paste Data, Pg 38 Expand Data Across Columns, Pg 36 Cells: Insert and Delete Cells, Pg 62 2. Create Cells and Ranges 2.2 Format Cells and Ranges Cells: Merge Cells, Pg 36 Cells: Modify Alignment, Indentation, Pg 34 Cells: Modify Font and Font Styles, Pg 31 Cells: Use the Format Painter, Pg 63 Cells: Wrap Text Within Cells, Pg 37 Cells: Apply Number Formatting, Pg 54 Cells: Apply Highlighting, Pg 33 Cells: Apply Cell Style, Pg 67 4. Apply formulas and Functions 4.2  Summarize Data with Functions Function: SUMIF, Pg 57 Function: MIN and MAX, Pg 93 Function: COUNT, Pg 92 Function: AVERAGE, Pg 90 Microsoft Excel 2013 Study Guide: Beginning Excel            Microsoft Office Specialist (MOS): Exam 77-420 for Excel 2013